package com.xxg.curd;

import java.util.List;
import java.util.Map;

/**
 * SQL 拼接
 */
public interface SQL {
    void createTable(String tableName, Map<String,Object> fieldsAndType, StringBuilder sql);
    void dropTable(String tableName, StringBuilder sql);

    void add(String tableName, List<Map<String,Object>> params, List<StringBuilder> sqlList) ;
    void deleteById(String tableName,List<String> ids, List<StringBuilder> sqlList) ;
    void updateById(String tableName,List<Map<String,Object>> params, List<StringBuilder> sqlList);

    void findById(String tableName,List<String> ids, StringBuilder sql) ;
    void pageBy(String tableName, int skip, int size, Map<String,Object> where, StringBuilder sql);
}
